<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Answering a prompt by defining a filter based on a metric calculation</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
p.whs2 { color:#000000; }
ul.whs3 { list-style:square; }
p.whs4 { margin-left:0px; }
img_whs5 { border:none; width:13px; height:16px; float:none; border-style:none; }
h3.whs6 { color:#000000; }
ul.whs7 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript">
<!--
if ((navigator.appName == "Netscape") && (parseInt(navigator.appVersion) == 4))
{
  var strNSS = "<style type='text/css'>";
  strNSS += "p.whs4 {margin-left:1pt; }";
  strNSS +="</style>";
  document.write(strNSS);
}
//-->
</script>
<script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Running and viewing reports and documents\nRunning and viewing a report\nAnswering questions for a prompted report\nAnswering a prompt by defining a filter based on a metric calculation");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Answering a prompt by defining a filter based on a metric calculation</h1>
<p>Some prompted reports require you to define your filtering conditions 
 based on a metric. These are metric prompts, in which you create a filter 
 for a metric to define the data that is displayed on the report.</p>
<p>If you attempt to run a report that contains a required prompt without 
 answering the required prompt, the report will not run, and a message 
 stating this requirement is displayed.</p>
<h2>To answer a prompt by defining a filter based on a metric</h2>
<ol type="1" class="whs1">
	
<li class=p><p>Click the name of a prompted report to run it. A prompted 
 report will present a prompt question to be answered before the report 
 data is displayed.</p></li>
	
<li class=p><p>If the prompt already has an answer (a filtering condition) 
 in the right pane, you can do one of the following:</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>Change the existing 
 answer (filtering condition) using the information in the next step.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p>Add other answers 
 (filtering conditions) to it using the information in the next step.</p></li>
		
<li style="list-style: disc;" type=disc class=p><p>Click <span 
 style="font-weight: bold;"><B>Next</B></span> and proceed to answer other prompts, 
 or if this was the only prompt, you can run the report or document.</p></li>
	</ul>
</ol>
<ol start="3" type="1" class="whs1">
	
<li class=p><p>If the prompt does not have an answer in the right pane, 
 or you want to add to or change answers (filtering conditions), create 
 your filter by performing all of the following:</p></li>
</ol>
<ul><ul>
<li style="list-style: disc;  color: #000000; " type=disc class=p><p class="whs2">Click in the right pane to start creating your 
 filter.</p></li>
		
<li style="list-style: disc;  color: #000000; " type=disc class=p><p class="whs2">If you want to select an output level, click <span 
 style="font-weight: bold;"><B>...</B></span> (browse) next to the <span style="font-weight: bold;"><B>Output 
 Level</B></span> field to select a level. The output level is the level at 
 which the metric results are calculated. The default is the metric’s level. 
 Output levels are discussed in detail in the <span style="font-style: italic;"><I>Advanced 
 Filters</I></span> chapter of the <span style="font-style: italic;"><I>MicroStrategy 
 Advanced Reporting Guide</I></span>.</p></li>
		
<li style="list-style: disc;  color: #000000; " type=disc class=p><p class="whs2">Depending on how the prompt’s creator designed 
 the prompt, you may be able to select the metric on which you want to 
 base your filter. Use one of the following methods:</p></li>
		<ul type="square" class="whs3">
			
<li style=" color: #000000; " class=p><p class="whs2">Type 
 the name of the metric in the <span style="font-weight: bold;"><B>Metric</B></span> 
 field and click <span style="font-weight: bold;"><B>OK</B></span>.</p></li>
			
<li style=" color: #000000; " class=p><p class="whs2">Click 
 <span style="font-weight: bold;"><B>...</B></span> (browse) to locate the metric. 
 In the Open dialog box, navigate to the folder that contains the metric, 
 select the metric, and click <span style="font-weight: bold;"><B>OK</B></span>.</p></li>
		</ul>
		
<li style="list-style: disc;  color: #000000; " type=disc class=p><p class="whs2">From the <span style="font-weight: bold;"><B>Function</B></span> 
 drop-down list, select the part of the metric that will be filtered on: 
 Metric Value, Rank, or Percent.</p></li>
		
<li style="list-style: disc;  color: #000000; " type=disc class=p><p class="whs2">From the <span style="font-weight: bold;"><B>Operator</B></span> 
 drop-down list, select a logical operator. For example, you might choose 
 the Greater Than operator to filter out data that is below a certain number. 
 For more details on operators, see <span style="font-style: italic;"><I>Joining 
 filter qualifications with operators</I></span> in the <span style="font-style: italic;"><I>MicroStrategy 
 Basic Reporting Guide</I></span>.</p></li>
		
<li style="list-style: disc;  color: #000000; " type=disc class=p><p class="whs2">Beside the <span style="font-weight: bold;"><B>Value</B></span> 
 field, enter the value to complete your chosen operator. For example, 
 if you chose the Greater Than operator above, you must enter the value 
 which data should be greater than, to be returned on the report.</p></li>
		
<li style="list-style: disc;  color: #000000; " type=disc class=p><p class="whs2">Click <span style="font-weight: bold;"><B>OK</B></span> 
 to close the Set Qualification pane.</p></li>
	</ul>
</ul>
<ol start="4" type="1" class="whs1">
	
<li style=" color: #000000; " class=p><p class="whs2">When 
 you are finished defining your filter, if there is another prompt on the 
 report or document scroll down or click <span style="font-weight: bold;"><B>Next</B></span> 
 to answer the next prompt. Use the appropriate steps to answer them.</p></li>
	
<li style=" color: #000000; " class=p><p class="whs2">When 
 you are finished answering all prompts, review the summary of your answers 
 and click <span style="font-weight: bold;"><B>Run Report</B></span> or <span 
 style="font-weight: bold;"><B>Run Document</B></span>. The report or document 
 is executed and your results are displayed. </p></li>
	
<li style=" color: #000000; " class=p><p class="whs2">If 
 you want to save and reuse your answers, see 
<a href="Save_prompt_answers.htm">Saving 
 and reusing prompt answers</a>.</p></li>
	
<li style=" color: #000000; color: #000000; " class=p><p class="whs2"><span 
 style="color: #000000;"><font color=black >If you want to see how your prompt answers were 
 used to create the report’s filter, select </font></span><span style="color: #000000; font-weight: bold;"><font color=black ><B>Report 
 Details </B></font></span><span style="color: #000000;"><font color=black >or </font></span><span style="color: #000000; font-weight: bold;"><font color=black ><B>Document 
 Details </B></font></span><span style="color: #000000;"><font color=black >from the </font></span><span style="color: #000000; font-weight: bold;"><font color=black ><B>File 
 </B></font></span><span style="color: #000000;"><font color=black >menu. Your prompt answers appear 
 in the form of report filtering conditions. You can also see whether a 
 cache was used to supply the results. If a cache was not used, the results 
 were taken from the latest data in your data source.</font></span></p></li>
</ol>
<p class="whs4">To see data filtered in a different way, click 
 the <span style="font-weight: bold;"><B>Reprompt</B></span> 
 icon <img src="images/reprompt.gif" x-maintain-ratio="TRUE" width="13px" height="16px" border="0" class="img_whs5"> on the toolbar that displays from the <span style="font-weight: bold;"><B>Home 
 </B></span><span>menu</span> and answer the prompt again to create a different 
 filter for the report results.</p>
<h2>Renaming a prompted report</h2>
<p>When you run a prompted report or document, you are presented with a 
 prompt before you see any report results. At the bottom of the prompt 
 selection page, you can rename the prompted report. This allows you to 
 choose a meaningful name that makes it easier to later find the report 
 or document in your History List or your My Reports folder.</p>
<p>For example, for a prompted sales report, if you answer a prompt question 
 by specifying the month of October, you can rename the report &quot;October 
 Sales&quot;. Note that this name change is reflected only in your personal 
 version of the report (in your History List or My Reports folder). It 
 does not change the actual name of the report object in MicroStrategy.</p>
<h3 class="whs6">Related topics</h3>
<ul type="disc" class="whs7">
	
<li class=p><p>
<a HREF="Answer_prompt_using_list.htm">Answering a prompt 
 by selecting answers from a list</a></p></li>
	
<li class=p><p>
<a HREF="Answer_prompt_with_value.htm">Answering a prompt 
 by typing a specific value</a></p></li>
	
<li class=p><p>
<a HREF="Answer_prompt_filter_on_attribute.htm">Answering 
 a prompt by defining a filter based on an attribute</a></p></li>
</ul>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
